﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO [BPMEngine].[dbo].[ObjectTypes]
           ([ObjectTypeId]
           ,[ObjectName]
           ,[ObjectTable]
           ,[ObjectClrType])
     VALUES
           (1,
           'ProcessDefinition',
           'ProcessDefinitions',
           'YasharEl.Infrastructure.ProcessEngine.IProcessDefinition'
           );

INSERT INTO [BPMEngine].[dbo].[ObjectTypes]
           ([ObjectTypeId]
           ,[ObjectName]
           ,[ObjectTable]
           ,[ObjectClrType])
     VALUES
           (2,
           'TaskDefinition',
           'TaskDefinitions',
           'YasharEl.Infrastructure.TaskEngine.ITaskDefinition'
           );

INSERT INTO [BPMEngine].[dbo].[ObjectTypes]
           ([ObjectTypeId]
           ,[ObjectName]
           ,[ObjectTable]
           ,[ObjectClrType])
     VALUES
           (3,
           'Task',
           'Tasks',
           'YasharEl.Infrastructure.TaskEngine.ITask'
           );

INSERT INTO [BPMEngine].[dbo].[ObjectTypes]
           ([ObjectTypeId]
           ,[ObjectName]
           ,[ObjectTable]
           ,[ObjectClrType])
     VALUES
           (4,
           'Process',
           'Processes',
           'YasharEl.Infrastructure.ProcessEngine.IProcess'
           );

GO